| SyStudent_Proxy |
| EntityType | Independent |
| Logical Entity Name | SyStudent_Proxy |
| Default Table Name | SyStudent_Proxy |
| Logical Only | NO |
| Definition | |
| Note |
| SyStudent_Proxy Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
SyStudent_ProxyID |
BIGINT | NO | ||
| RecordID | INTEGER | NO | ||
| OldSSN | VARCHAR(30) | YES | ||
| NewSSN | VARCHAR(30) | YES | ||
| OldLastName | VARCHAR(25) | NO | ||
| NewLastName | VARCHAR(25) | NO | ||
| OldFirstName | VARCHAR(25) | NO | ||
| NewFirstName | VARCHAR(25) | NO | ||
| OldMiddleName | VARCHAR(100) | YES | ||
| NewMiddleName | VARCHAR(100) | YES | ||
| OldAddr1 | VARCHAR(255) | NO | ||
| NewAddr1 | VARCHAR(255) | NO | ||
| OldCity | VARCHAR(25) | NO | ||
| NewCity | VARCHAR(25) | NO | ||
| OldState | CHAR(2) | NO | ||
| NewState | CHAR(2) | NO | ||
| OldZip | CHAR(10) | NO | ||
| NewZip | CHAR(10) | NO | ||
| OldSyCountryID | INTEGER | YES | ||
| NewSyCountryID | INTEGER | YES | ||
| OldSyCampusId | INTEGER | NO | ||
| NewSyCampusId | INTEGER | NO | ||
| OldPhone | CHAR(16) | NO | ||
| NewPhone | CHAR(16) | NO | ||
| OldWorkphone | CHAR(16) | NO | ||
| NewWorkphone | CHAR(16) | NO | ||
| OldOtherPhone | CHAR(16) | YES | ||
| NewOtherPhone | CHAR(16) | YES | ||
| OldEmail | VARCHAR(50) | NO | ||
| NewEmail | VARCHAR(50) | NO | ||
| OldOtherEmail | VARCHAR(50) | YES | ||
| NewOtherEmail | VARCHAR(50) | YES | ||
| OldLeadDate | DATETIME | YES | ||
| NewLeadDate | DATETIME | YES | ||
| OldAmRepId | INTEGER | NO | ||
| NewAmRepId | INTEGER | NO | ||
| OldAmLeadSrcId | INTEGER | NO | ||
| NewAmLeadSrcId | INTEGER | NO | ||
| OldAmLeadTypeId | INTEGER | NO | ||
| NewAmLeadTypeId | INTEGER | NO | ||
| OldAmCitizenID | INTEGER | NO | ||
| NewAmCitizenID | INTEGER | NO | ||
| OldAlienNo | CHAR(9) | YES | ||
| NewAlienNo | CHAR(9) | YES | ||
| OldAmMaritalID | INTEGER | NO | ||
| NewAmMaritalID | INTEGER | NO | ||
| OldDOB | DATETIME | YES | ||
| NewDOB | DATETIME | YES | ||
| OldAmSexID | INTEGER | NO | ||
| NewAmSexID | INTEGER | NO | ||
| OldAmRaceID | INTEGER | NO | ||
| NewAmRaceID | INTEGER | NO | ||
| OldAdProgramID | INTEGER | NO | ||
| NewAdProgramID | INTEGER | NO | ||
| UserID | INTEGER | NO | ||
| ModFlag | CHAR(1) | YES | ||
| OldSyCountyID | INTEGER | YES | ||
| NewSyCountyID | INTEGER | YES | ||
| OldStuNum | CHAR(10) | YES | ||
| NewStuNum | CHAR(10) | YES | ||
| OLDCMSMSServiceProviderID | INTEGER | YES | ||
| NEWCMSMSServiceProviderID | INTEGER | YES | ||
| OLDSubscribeToSMS | BIT | NO | ||
| NEWSubscribeToSMS | BIT | NO | ||
| OLDMobileNumber | VARCHAR(16) | YES | ||
| NEWMobileNumber | VARCHAR(16) | YES | ||
| OldAmPrevEducID | INTEGER | YES | ||
| NewAmPrevEducID | INTEGER | YES | ||
| OldIsHispanic | CHAR(1) | YES | ||
| NewIsHispanic | CHAR(1) | YES | ||
| DateAdded | DATETIME | NO | ||
| OldAthleticID | VARCHAR(20) | YES | ||
| NewAthleticID | VARCHAR(20) | YES | ||
| OldVet | CHAR(1) | YES | ||
| NewVet | CHAR(1) | YES |
| SyStudent_Proxy Keys |
| Key Name | Key Type | Keys |
| SyStudent_Proxy_SyStudent_ProxyID_U_C_IDX | PrimaryKey | SyStudent_ProxyID |
| SyStudent_Proxy Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SyStudent_Proxy Check Constraints |
| Check Constraint Name | CheckConstraint |